Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 40000 |
| Missing cells | 32187 |
| Missing cells (%) | 5.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.6 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 3 |
energy is highly correlated with loudness | High correlation |
loudness is highly correlated with energy | High correlation |
acousticness is highly correlated with energy and 1 other fields | High correlation |
energy is highly correlated with acousticness and 1 other fields | High correlation |
loudness is highly correlated with acousticness and 1 other fields | High correlation |
acousticness is highly correlated with energy and 1 other fields | High correlation |
energy is highly correlated with acousticness and 1 other fields | High correlation |
loudness is highly correlated with acousticness and 1 other fields | High correlation |
song_duration_ms has 4101 (10.3%) missing values | Missing |
acousticness has 3992 (10.0%) missing values | Missing |
danceability has 4026 (10.1%) missing values | Missing |
energy has 3975 (9.9%) missing values | Missing |
instrumentalness has 3985 (10.0%) missing values | Missing |
key has 4065 (10.2%) missing values | Missing |
liveness has 4086 (10.2%) missing values | Missing |
loudness has 3957 (9.9%) missing values | Missing |
id is uniformly distributed | Uniform |
id has unique values | Unique |
key has 5175 (12.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-01-28 17:49:29.316453 |
|---|---|
| Analysis finished | 2022-01-28 17:50:05.102063 |
| Duration | 35.79 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 40000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19999.5 |
| Minimum | 0 |
|---|---|
| Maximum | 39999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1999.95 |
| Q1 | 9999.75 |
| median | 19999.5 |
| Q3 | 29999.25 |
| 95-th percentile | 37999.05 |
| Maximum | 39999 |
| Range | 39999 |
| Interquartile range (IQR) | 19999.5 |
Descriptive statistics
| Standard deviation | 11547.14972 |
|---|---|
| Coefficient of variation (CV) | 0.5773719203 |
| Kurtosis | -1.2 |
| Mean | 19999.5 |
| Median Absolute Deviation (MAD) | 10000 |
| Skewness | 0 |
| Sum | 799980000 |
| Variance | 133336666.7 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 35492 | 1 | < 0.1% |
| 25241 | 1 | < 0.1% |
| 31386 | 1 | < 0.1% |
| 29339 | 1 | < 0.1% |
| 19100 | 1 | < 0.1% |
| 17053 | 1 | < 0.1% |
| 23198 | 1 | < 0.1% |
| 21151 | 1 | < 0.1% |
| 33445 | 1 | < 0.1% |
| Other values (39990) | 39990 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 39999 | 1 | |
| 39998 | 1 | |
| 39997 | 1 | |
| 39996 | 1 | |
| 39995 | 1 | |
| 39994 | 1 | |
| 39993 | 1 | |
| 39992 | 1 | |
| 39991 | 1 | |
| 39990 | 1 |
| Distinct | 31586 |
|---|---|
| Distinct (%) | 88.0% |
| Missing | 4101 |
| Missing (%) | 10.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 193165.8476 |
| Minimum | 25658 |
|---|---|
| Maximum | 491671 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 25658 |
|---|---|
| 5-th percentile | 127469.5 |
| Q1 | 166254.5 |
| median | 186660 |
| Q3 | 215116 |
| 95-th percentile | 277074.1 |
| Maximum | 491671 |
| Range | 466013 |
| Interquartile range (IQR) | 48861.5 |
Descriptive statistics
| Standard deviation | 45822.12768 |
|---|---|
| Coefficient of variation (CV) | 0.2372165072 |
| Kurtosis | 1.654184865 |
| Mean | 193165.8476 |
| Median Absolute Deviation (MAD) | 23432 |
| Skewness | 0.632931575 |
| Sum | 6934460762 |
| Variance | 2099667385 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 162048 | 6 | < 0.1% |
| 160369 | 5 | < 0.1% |
| 174546 | 5 | < 0.1% |
| 191521 | 4 | < 0.1% |
| 166676 | 4 | < 0.1% |
| 166747 | 4 | < 0.1% |
| 183534 | 4 | < 0.1% |
| 182627 | 4 | < 0.1% |
| 187889 | 4 | < 0.1% |
| 172888 | 4 | < 0.1% |
| Other values (31576) | 35855 | |
| (Missing) | 4101 | 10.3% |
| Value | Count | Frequency (%) |
| 25658 | 1 | |
| 33994 | 1 | |
| 34816 | 1 | |
| 38861 | 1 | |
| 42109 | 1 | |
| 42856 | 1 | |
| 43971 | 1 | |
| 44008 | 1 | |
| 44834 | 1 | |
| 44839 | 1 |
| Value | Count | Frequency (%) |
| 491671 | 1 | |
| 470577 | 1 | |
| 465636 | 1 | |
| 444971 | 1 | |
| 441046 | 1 | |
| 428156 | 1 | |
| 427888 | 1 | |
| 424144 | 1 | |
| 424135 | 1 | |
| 422771 | 1 |
| Distinct | 36004 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 3992 |
| Missing (%) | 10.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2764044304 |
| Minimum | -0.01355115526 |
|---|---|
| Maximum | 1.065284361 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 372 |
| Negative (%) | 0.9% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | -0.01355115526 |
|---|---|
| 5-th percentile | 0.006948470296 |
| Q1 | 0.0396183645 |
| median | 0.1405323489 |
| Q3 | 0.4824987531 |
| 95-th percentile | 0.9144326981 |
| Maximum | 1.065284361 |
| Range | 1.078835516 |
| Interquartile range (IQR) | 0.4428803886 |
Descriptive statistics
| Standard deviation | 0.2979279293 |
|---|---|
| Coefficient of variation (CV) | 1.077869587 |
| Kurtosis | -0.3117888002 |
| Mean | 0.2764044304 |
| Median Absolute Deviation (MAD) | 0.1257318182 |
| Skewness | 1.004194448 |
| Sum | 9952.770729 |
| Variance | 0.08876105104 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.1298648705 | 2 | < 0.1% |
| 0.2686247767 | 2 | < 0.1% |
| 0.01231633709 | 2 | < 0.1% |
| 0.02305824137 | 2 | < 0.1% |
| 0.1299048141 | 1 | < 0.1% |
| 0.1603511393 | 1 | < 0.1% |
| 0.6220500299 | 1 | < 0.1% |
| 0.1369081355 | 1 | < 0.1% |
| 0.3712757452 | 1 | < 0.1% |
| 0.8582999413 | 1 | < 0.1% |
| Other values (35994) | 35994 | |
| (Missing) | 3992 | 10.0% |
| Value | Count | Frequency (%) |
| -0.01355115526 | 1 | |
| -0.01224546206 | 1 | |
| -0.01215610495 | 1 | |
| -0.01099993806 | 1 | |
| -0.0108470341 | 1 | |
| -0.01076639126 | 1 | |
| -0.01035210674 | 1 | |
| -0.009692163825 | 1 | |
| -0.009676017858 | 1 | |
| -0.009572675809 | 1 |
| Value | Count | Frequency (%) |
| 1.065284361 | 1 | |
| 1.062515738 | 1 | |
| 1.062462697 | 1 | |
| 1.051164071 | 1 | |
| 1.045537383 | 1 | |
| 1.043691471 | 1 | |
| 1.04108687 | 1 | |
| 1.040336623 | 1 | |
| 1.037488945 | 1 | |
| 1.036745377 | 1 |
| Distinct | 35972 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 4026 |
| Missing (%) | 10.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5709511548 |
| Minimum | 0.04396067634 |
|---|---|
| Maximum | 0.9571308047 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0.04396067634 |
|---|---|
| 5-th percentile | 0.2329293652 |
| Q1 | 0.4247604608 |
| median | 0.6082338356 |
| Q3 | 0.7184637554 |
| 95-th percentile | 0.839682299 |
| Maximum | 0.9571308047 |
| Range | 0.9131701284 |
| Interquartile range (IQR) | 0.2937032947 |
Descriptive statistics
| Standard deviation | 0.1900104818 |
|---|---|
| Coefficient of variation (CV) | 0.3327963875 |
| Kurtosis | -0.8125678234 |
| Mean | 0.5709511548 |
| Median Absolute Deviation (MAD) | 0.137040659 |
| Skewness | -0.3983857384 |
| Sum | 20539.39684 |
| Variance | 0.03610398319 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.3484417356 | 2 | < 0.1% |
| 0.4822726741 | 2 | < 0.1% |
| 0.7295594728 | 1 | < 0.1% |
| 0.15499943 | 1 | < 0.1% |
| 0.1824723205 | 1 | < 0.1% |
| 0.45001977 | 1 | < 0.1% |
| 0.6335571136 | 1 | < 0.1% |
| 0.7641628936 | 1 | < 0.1% |
| 0.4916792322 | 1 | < 0.1% |
| 0.6922194535 | 1 | < 0.1% |
| Other values (35962) | 35962 | |
| (Missing) | 4026 | 10.1% |
| Value | Count | Frequency (%) |
| 0.04396067634 | 1 | |
| 0.04980707564 | 1 | |
| 0.05368199231 | 1 | |
| 0.05626872024 | 1 | |
| 0.05707968785 | 1 | |
| 0.05913749752 | 1 | |
| 0.06383802657 | 1 | |
| 0.06813417292 | 1 | |
| 0.06943161099 | 1 | |
| 0.07296815652 | 1 |
| Value | Count | Frequency (%) |
| 0.9571308047 | 1 | |
| 0.9549446559 | 1 | |
| 0.950358401 | 1 | |
| 0.9477322566 | 1 | |
| 0.940680788 | 1 | |
| 0.9395229394 | 1 | |
| 0.935242386 | 1 | |
| 0.9331280429 | 1 | |
| 0.9331100089 | 1 | |
| 0.9329243581 | 1 |
| Distinct | 36021 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 3975 |
| Missing (%) | 9.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6839319477 |
| Minimum | -0.001682200414 |
|---|---|
| Maximum | 1.039741305 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | -0.001682200414 |
|---|---|
| 5-th percentile | 0.2827326087 |
| Q1 | 0.5392758057 |
| median | 0.7044533183 |
| Q3 | 0.8705031183 |
| 95-th percentile | 0.9606421252 |
| Maximum | 1.039741305 |
| Range | 1.041423505 |
| Interquartile range (IQR) | 0.3312273125 |
Descriptive statistics
| Standard deviation | 0.2126620002 |
|---|---|
| Coefficient of variation (CV) | 0.3109402929 |
| Kurtosis | -0.4092486749 |
| Mean | 0.6839319477 |
| Median Absolute Deviation (MAD) | 0.1657402625 |
| Skewness | -0.5828321649 |
| Sum | 24638.64842 |
| Variance | 0.04522512632 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.8348283406 | 2 | < 0.1% |
| 0.7988072464 | 2 | < 0.1% |
| 0.894791715 | 2 | < 0.1% |
| 0.8531411891 | 2 | < 0.1% |
| 0.6859723922 | 1 | < 0.1% |
| 0.8525037041 | 1 | < 0.1% |
| 0.6390753865 | 1 | < 0.1% |
| 0.6296781648 | 1 | < 0.1% |
| 0.8642854442 | 1 | < 0.1% |
| 0.6626464467 | 1 | < 0.1% |
| Other values (36011) | 36011 | |
| (Missing) | 3975 | 9.9% |
| Value | Count | Frequency (%) |
| -0.001682200414 | 1 | |
| 0.002322425173 | 1 | |
| 0.007113470935 | 1 | |
| 0.01673206131 | 1 | |
| 0.01804640285 | 1 | |
| 0.01835167109 | 1 | |
| 0.02139428561 | 1 | |
| 0.02275668041 | 1 | |
| 0.02382117205 | 1 | |
| 0.02728486912 | 1 |
| Value | Count | Frequency (%) |
| 1.039741305 | 1 | |
| 1.034280588 | 1 | |
| 1.033746655 | 1 | |
| 1.033434247 | 1 | |
| 1.033239424 | 1 | |
| 1.030409413 | 1 | |
| 1.029799364 | 1 | |
| 1.028632224 | 1 | |
| 1.028342585 | 1 | |
| 1.028060551 | 1 |
| Distinct | 35999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 3985 |
| Missing (%) | 10.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03652675599 |
| Minimum | -0.004398050997 |
|---|---|
| Maximum | 1.075414681 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 3216 |
| Negative (%) | 8.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | -0.004398050997 |
|---|---|
| 5-th percentile | -0.0004201654271 |
| Q1 | 0.0009414648076 |
| median | 0.00197447663 |
| Q3 | 0.003225298806 |
| 95-th percentile | 0.1489803127 |
| Maximum | 1.075414681 |
| Range | 1.079812732 |
| Interquartile range (IQR) | 0.002283833998 |
Descriptive statistics
| Standard deviation | 0.1500239025 |
|---|---|
| Coefficient of variation (CV) | 4.107233135 |
| Kurtosis | 24.17958059 |
| Mean | 0.03652675599 |
| Median Absolute Deviation (MAD) | 0.001120578988 |
| Skewness | 4.947630572 |
| Sum | 1315.511117 |
| Variance | 0.02250717132 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.001850425736 | 2 | < 0.1% |
| 0.001805457303 | 2 | < 0.1% |
| 0.001291602062 | 2 | < 0.1% |
| 0.001272046579 | 2 | < 0.1% |
| 0.002380006189 | 2 | < 0.1% |
| 0.001531513764 | 2 | < 0.1% |
| 0.001718744122 | 2 | < 0.1% |
| 0.002315629083 | 2 | < 0.1% |
| 0.0004818401054 | 2 | < 0.1% |
| 0.002195156381 | 2 | < 0.1% |
| Other values (35989) | 35995 | |
| (Missing) | 3985 | 10.0% |
| Value | Count | Frequency (%) |
| -0.004398050997 | 1 | |
| -0.003854102211 | 1 | |
| -0.003641069423 | 1 | |
| -0.003257875762 | 1 | |
| -0.003226164562 | 1 | |
| -0.003087703173 | 1 | |
| -0.003017105748 | 1 | |
| -0.002977129903 | 1 | |
| -0.002950045953 | 1 | |
| -0.002839981101 | 1 |
| Value | Count | Frequency (%) |
| 1.075414681 | 1 | |
| 1.064847378 | 1 | |
| 1.041479479 | 1 | |
| 1.036928136 | 1 | |
| 1.030262682 | 1 | |
| 1.029300219 | 1 | |
| 1.022304142 | 1 | |
| 1.015568836 | 1 | |
| 1.012839849 | 1 | |
| 1.012354366 | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4065 |
| Missing (%) | 10.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.042604703 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 5175 |
| Zeros (%) | 12.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.372727801 |
|---|---|
| Coefficient of variation (CV) | 0.6688463601 |
| Kurtosis | -1.274787585 |
| Mean | 5.042604703 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.07530404301 |
| Sum | 181206 |
| Variance | 11.37529282 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5175 | |
| 6 | 4949 | |
| 10 | 4302 | |
| 2 | 4080 | |
| 8 | 3028 | |
| 5 | 2985 | |
| 9 | 2881 | |
| 7 | 2690 | |
| 4 | 2239 | |
| 1 | 2143 | |
| Other values (2) | 1463 | 3.7% |
| (Missing) | 4065 |
| Value | Count | Frequency (%) |
| 0 | 5175 | |
| 1 | 2143 | |
| 2 | 4080 | |
| 3 | 1346 | 3.4% |
| 4 | 2239 | |
| 5 | 2985 | |
| 6 | 4949 | |
| 7 | 2690 | |
| 8 | 3028 | |
| 9 | 2881 |
| Value | Count | Frequency (%) |
| 11 | 117 | 0.3% |
| 10 | 4302 | |
| 9 | 2881 | |
| 8 | 3028 | |
| 7 | 2690 | |
| 6 | 4949 | |
| 5 | 2985 | |
| 4 | 2239 | |
| 3 | 1346 | 3.4% |
| 2 | 4080 |
| Distinct | 35911 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 4086 |
| Missing (%) | 10.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1985136912 |
| Minimum | 0.02784311302 |
|---|---|
| Maximum | 1.065298031 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0.02784311302 |
|---|---|
| 5-th percentile | 0.07990015233 |
| Q1 | 0.1117963607 |
| median | 0.1359451827 |
| Q3 | 0.2128416344 |
| 95-th percentile | 0.5817990771 |
| Maximum | 1.065298031 |
| Range | 1.037454918 |
| Interquartile range (IQR) | 0.1010452737 |
Descriptive statistics
| Standard deviation | 0.1516699134 |
|---|---|
| Coefficient of variation (CV) | 0.7640274707 |
| Kurtosis | 4.411722538 |
| Mean | 0.1985136912 |
| Median Absolute Deviation (MAD) | 0.03733661592 |
| Skewness | 2.165545688 |
| Sum | 7129.420707 |
| Variance | 0.02300376264 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.1364655957 | 2 | < 0.1% |
| 0.1192752827 | 2 | < 0.1% |
| 0.1317763064 | 2 | < 0.1% |
| 0.5903744356 | 1 | < 0.1% |
| 0.2207329301 | 1 | < 0.1% |
| 0.1043682297 | 1 | < 0.1% |
| 0.1997512769 | 1 | < 0.1% |
| 0.2012847652 | 1 | < 0.1% |
| 0.120359166 | 1 | < 0.1% |
| 0.4660245776 | 1 | < 0.1% |
| Other values (35901) | 35901 | |
| (Missing) | 4086 | 10.2% |
| Value | Count | Frequency (%) |
| 0.02784311302 | 1 | |
| 0.03029814242 | 1 | |
| 0.03125165841 | 1 | |
| 0.03230646959 | 1 | |
| 0.03278167164 | 1 | |
| 0.03452495219 | 1 | |
| 0.03459704388 | 1 | |
| 0.03528012524 | 1 | |
| 0.03611065173 | 1 | |
| 0.0369193823 | 1 |
| Value | Count | Frequency (%) |
| 1.065298031 | 1 | |
| 1.0286 | 1 | |
| 0.9902235113 | 1 | |
| 0.9804107246 | 1 | |
| 0.9796324509 | 1 | |
| 0.9784863951 | 1 | |
| 0.9754442737 | 1 | |
| 0.9703675478 | 1 | |
| 0.9591490081 | 1 | |
| 0.9544000324 | 1 |
| Distinct | 36038 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 3957 |
| Missing (%) | 9.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -7.407596208 |
| Minimum | -32.11791085 |
|---|---|
| Maximum | -0.8773458492 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 36043 |
| Negative (%) | 90.1% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | -32.11791085 |
|---|---|
| 5-th percentile | -14.81626983 |
| Q1 | -9.578139218 |
| median | -6.345412615 |
| Q3 | -4.620711264 |
| 95-th percentile | -3.029093555 |
| Maximum | -0.8773458492 |
| Range | 31.240565 |
| Interquartile range (IQR) | 4.957427954 |
Descriptive statistics
| Standard deviation | 3.877197599 |
|---|---|
| Coefficient of variation (CV) | -0.5234083353 |
| Kurtosis | 2.79043824 |
| Mean | -7.407596208 |
| Median Absolute Deviation (MAD) | 2.118409249 |
| Skewness | -1.430100333 |
| Sum | -266991.9901 |
| Variance | 15.03266123 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -4.824933232 | 2 | < 0.1% |
| -2.703761573 | 2 | < 0.1% |
| -9.930080784 | 2 | < 0.1% |
| -11.10901141 | 2 | < 0.1% |
| -5.754275152 | 2 | < 0.1% |
| -3.986829937 | 1 | < 0.1% |
| -12.3152942 | 1 | < 0.1% |
| -13.06102649 | 1 | < 0.1% |
| -9.743439882 | 1 | < 0.1% |
| -21.76251432 | 1 | < 0.1% |
| Other values (36028) | 36028 | |
| (Missing) | 3957 | 9.9% |
| Value | Count | Frequency (%) |
| -32.11791085 | 1 | |
| -30.17039853 | 1 | |
| -30.09107426 | 1 | |
| -30.08884236 | 1 | |
| -30.01238622 | 1 | |
| -29.597087 | 1 | |
| -29.36123409 | 1 | |
| -29.1999107 | 1 | |
| -29.17544778 | 1 | |
| -29.04399434 | 1 |
| Value | Count | Frequency (%) |
| -0.8773458492 | 1 | |
| -1.073216639 | 1 | |
| -1.099458021 | 1 | |
| -1.125853573 | 1 | |
| -1.173570927 | 1 | |
| -1.204069609 | 1 | |
| -1.214176797 | 1 | |
| -1.218480288 | 1 | |
| -1.226753925 | 1 | |
| -1.235716026 | 1 |
audio_mode
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 312.6 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 27154 | |
| 1 | 12846 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 27154 | |
| 1 | 12846 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
speechiness
Real number (ℝ≥0)
| Distinct | 39999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09410654997 |
| Minimum | 0.01506465912 |
|---|---|
| Maximum | 0.5607483509 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0.01506465912 |
|---|---|
| 5-th percentile | 0.02929199988 |
| Q1 | 0.03850013208 |
| median | 0.05588077326 |
| Q3 | 0.1188421391 |
| 95-th percentile | 0.2765419244 |
| Maximum | 0.5607483509 |
| Range | 0.5456836918 |
| Interquartile range (IQR) | 0.08034200698 |
Descriptive statistics
| Standard deviation | 0.08359080853 |
|---|---|
| Coefficient of variation (CV) | 0.8882570719 |
| Kurtosis | 2.47562356 |
| Mean | 0.09410654997 |
| Median Absolute Deviation (MAD) | 0.02167172596 |
| Skewness | 1.72012054 |
| Sum | 3764.261999 |
| Variance | 0.006987423271 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0333236877 | 2 | < 0.1% |
| 0.1008647319 | 1 | < 0.1% |
| 0.07035114219 | 1 | < 0.1% |
| 0.03681558906 | 1 | < 0.1% |
| 0.3407435176 | 1 | < 0.1% |
| 0.1747890063 | 1 | < 0.1% |
| 0.02650533038 | 1 | < 0.1% |
| 0.1737324419 | 1 | < 0.1% |
| 0.03549234342 | 1 | < 0.1% |
| 0.2614746642 | 1 | < 0.1% |
| Other values (39989) | 39989 |
| Value | Count | Frequency (%) |
| 0.01506465912 | 1 | |
| 0.01515337083 | 1 | |
| 0.01564763501 | 1 | |
| 0.01833354331 | 1 | |
| 0.01853498414 | 1 | |
| 0.01879262041 | 1 | |
| 0.01888181812 | 1 | |
| 0.01888251654 | 1 | |
| 0.019010372 | 1 | |
| 0.01903601699 | 1 |
| Value | Count | Frequency (%) |
| 0.5607483509 | 1 | |
| 0.5510141697 | 1 | |
| 0.5477989681 | 1 | |
| 0.5332567197 | 1 | |
| 0.5306210907 | 1 | |
| 0.5274952514 | 1 | |
| 0.5190122249 | 1 | |
| 0.5158757556 | 1 | |
| 0.5149116625 | 1 | |
| 0.5083094875 | 1 |
tempo
Real number (ℝ≥0)
| Distinct | 39993 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.5628149 |
| Minimum | 62.05577908 |
|---|---|
| Maximum | 219.1635782 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 62.05577908 |
|---|---|
| 5-th percentile | 81.3193984 |
| Q1 | 96.99530887 |
| median | 113.7959594 |
| Q3 | 128.5173834 |
| 95-th percentile | 170.9800477 |
| Maximum | 219.1635782 |
| Range | 157.1077991 |
| Interquartile range (IQR) | 31.52207449 |
Descriptive statistics
| Standard deviation | 26.16791062 |
|---|---|
| Coefficient of variation (CV) | 0.2244962139 |
| Kurtosis | 0.1752832209 |
| Mean | 116.5628149 |
| Median Absolute Deviation (MAD) | 16.00719581 |
| Skewness | 0.7641500817 |
| Sum | 4662512.595 |
| Variance | 684.7595463 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 88.09594918 | 2 | < 0.1% |
| 90.56198771 | 2 | < 0.1% |
| 95.06923582 | 2 | < 0.1% |
| 88.18238954 | 2 | < 0.1% |
| 103.1900773 | 2 | < 0.1% |
| 127.0865076 | 2 | < 0.1% |
| 111.827571 | 2 | < 0.1% |
| 139.234579 | 1 | < 0.1% |
| 91.92083795 | 1 | < 0.1% |
| 106.6759308 | 1 | < 0.1% |
| Other values (39983) | 39983 |
| Value | Count | Frequency (%) |
| 62.05577908 | 1 | |
| 62.88900161 | 1 | |
| 63.24833569 | 1 | |
| 63.45744669 | 1 | |
| 63.4788765 | 1 | |
| 63.47941256 | 1 | |
| 63.53043311 | 1 | |
| 63.75748185 | 1 | |
| 63.97720182 | 1 | |
| 63.99473878 | 1 |
| Value | Count | Frequency (%) |
| 219.1635782 | 1 | |
| 218.6374389 | 1 | |
| 215.8613677 | 1 | |
| 212.5435496 | 1 | |
| 212.4254819 | 1 | |
| 211.7864762 | 1 | |
| 211.5793805 | 1 | |
| 211.1612702 | 1 | |
| 211.0914066 | 1 | |
| 210.480838 | 1 |
time_signature
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 312.6 KiB |
| 3 | |
|---|---|
| 4 | |
| 2 | 530 |
| 5 | 193 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 23358 | |
| 4 | 15919 | |
| 2 | 530 | 1.3% |
| 5 | 193 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 3 | 23358 | |
| 4 | 15919 | |
| 2 | 530 | 1.3% |
| 5 | 193 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
audio_valence
Real number (ℝ≥0)
| Distinct | 39998 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5806448561 |
| Minimum | 0.01339785461 |
|---|---|
| Maximum | 1.022557576 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 312.6 KiB |
Quantile statistics
| Minimum | 0.01339785461 |
|---|---|
| 5-th percentile | 0.1591460592 |
| Q1 | 0.3986694172 |
| median | 0.5988269955 |
| Q3 | 0.7596351387 |
| 95-th percentile | 0.9474466885 |
| Maximum | 1.022557576 |
| Range | 1.009159721 |
| Interquartile range (IQR) | 0.3609657215 |
Descriptive statistics
| Standard deviation | 0.2373507637 |
|---|---|
| Coefficient of variation (CV) | 0.4087709745 |
| Kurtosis | -0.858197458 |
| Mean | 0.5806448561 |
| Median Absolute Deviation (MAD) | 0.1804709655 |
| Skewness | -0.1810057441 |
| Sum | 23225.79424 |
| Variance | 0.05633538502 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.7457151873 | 2 | < 0.1% |
| 0.6859068849 | 2 | < 0.1% |
| 0.3568781277 | 1 | < 0.1% |
| 0.8643191672 | 1 | < 0.1% |
| 0.2079348175 | 1 | < 0.1% |
| 0.4293615567 | 1 | < 0.1% |
| 0.1475367375 | 1 | < 0.1% |
| 0.5910507462 | 1 | < 0.1% |
| 0.8189060331 | 1 | < 0.1% |
| 0.4127207868 | 1 | < 0.1% |
| Other values (39988) | 39988 |
| Value | Count | Frequency (%) |
| 0.01339785461 | 1 | |
| 0.01735138702 | 1 | |
| 0.02005064357 | 1 | |
| 0.0239495843 | 1 | |
| 0.02765734359 | 1 | |
| 0.02956553866 | 1 | |
| 0.03038483533 | 1 | |
| 0.03141770541 | 1 | |
| 0.0315559735 | 1 | |
| 0.03290055633 | 1 |
| Value | Count | Frequency (%) |
| 1.022557576 | 1 | |
| 1.022282685 | 1 | |
| 1.018570938 | 1 | |
| 1.018301592 | 1 | |
| 1.017692764 | 1 | |
| 1.015200333 | 1 | |
| 1.013484216 | 1 | |
| 1.013445519 | 1 | |
| 1.013055487 | 1 | |
| 1.012928548 | 1 |
song_popularity
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 312.6 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 25424 | |
| 1 | 14576 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 25424 | |
| 1 | 14576 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| id | song_duration_ms | acousticness | danceability | energy | instrumentalness | key | liveness | loudness | audio_mode | speechiness | tempo | time_signature | audio_valence | song_popularity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 212990.0 | 0.642286 | 0.856520 | 0.707073 | 0.002001 | 10.0 | NaN | -5.619088 | 0 | 0.082570 | 158.386236 | 4 | 0.734642 | 0 |
| 1 | 1 | NaN | 0.054866 | 0.733289 | 0.835545 | 0.000996 | 8.0 | 0.436428 | -5.236965 | 1 | 0.127358 | 102.752988 | 3 | 0.711531 | 1 |
| 2 | 2 | 193213.0 | NaN | 0.188387 | 0.783524 | -0.002694 | 5.0 | 0.170499 | -4.951759 | 0 | 0.052282 | 178.685791 | 3 | 0.425536 | 0 |
| 3 | 3 | 249893.0 | 0.488660 | 0.585234 | 0.552685 | 0.000608 | 0.0 | 0.094805 | -7.893694 | 0 | 0.035618 | 128.715630 | 3 | 0.453597 | 0 |
| 4 | 4 | 165969.0 | 0.493017 | NaN | 0.740982 | 0.002033 | 10.0 | 0.094891 | -2.684095 | 0 | 0.050746 | 121.928157 | 4 | 0.741311 | 0 |
| 5 | 5 | 188891.0 | 0.035655 | 0.825919 | 0.804528 | -0.000005 | 4.0 | 0.120758 | -6.122926 | 0 | 0.039012 | 115.679128 | 4 | 0.709408 | 0 |
| 6 | 6 | 161061.0 | 0.081743 | 0.673588 | 0.880181 | 0.000327 | 0.0 | 0.535411 | -2.909607 | 1 | 0.030902 | 98.046205 | 4 | 0.982729 | 0 |
| 7 | 7 | 196202.0 | 0.259747 | 0.813214 | 0.554385 | 0.000390 | 8.0 | 0.276580 | -7.794237 | 0 | 0.207067 | 158.626764 | 3 | 0.662987 | 1 |
| 8 | 8 | 169660.0 | NaN | 0.653263 | 0.917034 | 0.001748 | 0.0 | NaN | -4.422089 | 0 | 0.031608 | 122.382398 | 3 | 0.297683 | 1 |
| 9 | 9 | 167245.0 | 0.019617 | 0.595235 | 0.820039 | 0.761884 | 5.0 | 0.181098 | -5.154293 | 0 | 0.054493 | 110.524824 | 4 | 0.535453 | 0 |
Last rows
| id | song_duration_ms | acousticness | danceability | energy | instrumentalness | key | liveness | loudness | audio_mode | speechiness | tempo | time_signature | audio_valence | song_popularity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39990 | 39990 | 161037.0 | NaN | 0.180815 | 0.353495 | 0.006077 | 2.0 | 0.123413 | -16.852685 | 0 | 0.034193 | 79.630026 | 3 | 0.437497 | 1 |
| 39991 | 39991 | 171968.0 | 0.139985 | NaN | 0.697060 | 0.000127 | 0.0 | 0.216089 | -7.560009 | 1 | 0.169939 | 86.469992 | 3 | 0.722420 | 0 |
| 39992 | 39992 | 402730.0 | 0.006045 | 0.650712 | NaN | 0.002694 | 10.0 | 0.215647 | -2.619994 | 0 | 0.059303 | 116.791531 | 4 | 0.525806 | 0 |
| 39993 | 39993 | 147151.0 | 0.106588 | 0.616430 | 0.923022 | 0.003327 | 6.0 | 0.066085 | -4.017034 | 0 | 0.185710 | 118.632683 | 4 | 0.393328 | 1 |
| 39994 | 39994 | 158043.0 | NaN | 0.256182 | 0.699162 | 0.002757 | 10.0 | 0.385996 | -9.917717 | 0 | 0.042718 | 103.431785 | 4 | 0.208892 | 1 |
| 39995 | 39995 | 237799.0 | NaN | 0.748942 | 0.511234 | 0.002913 | 0.0 | 0.173803 | -8.853673 | 0 | 0.078060 | 168.262924 | 3 | 0.178159 | 0 |
| 39996 | 39996 | 191119.0 | 0.067488 | 0.672830 | 0.889685 | 0.001225 | 5.0 | 0.122924 | -7.798993 | 0 | 0.188607 | 110.684544 | 3 | 0.790626 | 0 |
| 39997 | 39997 | 160879.0 | 0.877431 | 0.409065 | 0.292671 | NaN | 10.0 | 0.110664 | -15.378585 | 0 | 0.031294 | 99.556074 | 3 | 0.177947 | 1 |
| 39998 | 39998 | 193918.0 | NaN | 0.365738 | NaN | 0.000339 | 1.0 | 0.356308 | -4.661977 | 1 | 0.054096 | 139.857384 | 3 | 0.772978 | 0 |
| 39999 | 39999 | 196475.0 | 0.007116 | 0.354585 | 0.994883 | 0.002191 | 1.0 | 0.200900 | -4.875249 | 0 | 0.080549 | 101.974949 | 3 | 0.588549 | 0 |